select a.dftpic as dftpic1, b.Latitude as b_Latitude, b.Longitude as b_Longitude,* from [houses] a, [base_property] b, [base_cityDistrict] c where audit=1 and a.pid = b.pid and b.did = c.id and a.del=0 and a.locker=0 and b.del=0 and b.locker=0 and a.isShowEn=0 and a.houseType = 1 and (b.cnpropertyname like '%Old House in TaiAn Road%' or b.enpropertyname like '%Old House in TaiAn Road%') order by updateTime Desc, a.dftpic desc
The landlord invites famous designer to design this house,Italian minimalist fashion style.Luxury deco with floor heating,contemporary open kitchen,full furnish...
Located at Taixing Rd and Xingguo Rd. a quiet house in a prosperous city. This home is well designed by famous home designer. The landlord may rearrange the...
The property comprises a generous living room, contemporary kitchen with open-plan dining room. Generous outside space and breathtaking panoramic views; Good de...